[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002072s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > 0 AND `post`.`published_time` < 1716118328 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN (1,79,90,92,93,94,95,96,97,98,99,100,101,102) GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`create_time` DESC LIMIT 100 [ RunTime:0.002552s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > 0 AND `post`.`published_time` < 1716118328 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN (3,75,91,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121) GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`create_time` DESC LIMIT 100 [ RunTime:0.002542s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000258s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > 0 AND `post`.`published_time` < 1716118328 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN (1,79,90,92,93,94,95,96,97,98,99,100,101,102) GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`create_time` DESC LIMIT 100 [ RunTime:0.002236s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > 0 AND `post`.`published_time` < 1716118328 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN (3,75,91,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121) GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`create_time` DESC LIMIT 100 [ RunTime:0.002464s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000234s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000189s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > 0 AND `post`.`published_time` < 1716118328 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = 76 GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000597s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > 0 AND `post`.`published_time` < 1716118328 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = 76 GROUP BY `post`.`id` ORDER BY `post`.`list_order` DESC LIMIT 0,3 [ RunTime:0.001917s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > 0 AND `post`.`published_time` < 1716118328 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN (1,79,90,92,93,94,95,96,97,98,99,100,101,102) GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`create_time` DESC LIMIT 100 [ RunTime:0.002215s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > 0 AND `post`.`published_time` < 1716118328 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN (3,75,91,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121) GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`create_time` DESC LIMIT 100 [ RunTime:0.002461s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > 0 AND `post`.`published_time` < 1716118328 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN (1,79,90,92,93,94,95,96,97,98,99,100,101,102) GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`create_time` DESC LIMIT 100 [ RunTime:0.002222s ]